﻿CREATE PROCEDURE [dbo].[ListProjectForEngineer]
@userID INT
AS
SELECT p.ProjectID, Name as ProjectName, Description 
FROM Projects p
	INNER JOIN ProjectMembers pm
	ON p.ProjectID = pm.ProjectID
WHERE pm.UserID=@userID
	RETURN

